The Database API > Database API functions > MMDB.getSPColumnList()

 

MMDB.getSPColumnList()

Availability

Dreamweaver UltraDev 1.0

Description

Gets a list of result set columns that are generated by a call to the specified stored procedure.

Arguments

connName, statement, paramValuesArray

connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.
statement is the name of the stored procedure that returns the result set when executed.
paramValuesArray is an array containing a list of design-time parameter test values. Specify the parameter values in the order in which the stored procedure expects them. You can use the MMDB.getSPParamsAsString() function to get the parameters of the stored procedure.

Returns

An array of strings representing the list of columns. This function returns an error if the SQL statement is invalid or if the connection string is wrong.

Example

The following code could return a list of result set columns that were generated from the executed stored procedure, getNewEmployeesMakingAtLeast:

var paramValueArray = new Array("2/1/2000", "50000")
var columnArray = MMDB.getSPColumnList("EmpDB", ¬
"getNewEmployeesMakingAtLeast", paramValueArray)

These are the returned values:

columnArray[0] = "EmpID", columnArray[1] = "LastName", ¬
columnArray[2] ="startDate", columnArray[3] = "salary"